//
//  所有操作(查询、更新)数据库的静态方法
//  DataBaseAccess.h
//  X-Touch2
//
//  Created by shengchao yang on 12-3-7.
//  Copyright (c) 2012年 foxhis. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "FMDatabase.h"
@class PluFood,PluPlu,PluCigarete,PluDrink,MyOrderMenus,MyOrderPluPkgs;

@interface DataBaseAccess : NSObject
+(void) testPinyin;
+(MyOrderMenus *) getOrderMenuByPbCode:(NSString *)pbCode;
+(MyOrderMenus *) getOrderMenuByMomLocalMenu:(NSString *)momLocalMenu;
+(NSMutableArray *) selectPluTable:(NSString *)sql;
+(NSMutableArray *) selectPluEmpno:(NSString *)sql;
+(NSMutableArray *) selectPluSpecialSort:(NSString *)sql;
+(NSMutableArray *) selectPluSpecialCode:(NSString *)sql;
+(NSMutableArray *) selectPluBook:(NSString *)sql;
+(NSMutableArray *) selectPluMenu:(NSString *)sql;
+(NSMutableArray *) selectPluSort:(NSString *)sql;
+(NSMutableArray *) selectPluPlu:(NSString *)sql;
+(NSMutableArray *) selectMyOrderDishes:(NSString *)sql;
+(NSMutableArray *) selectMyOrderPluPkgs:(NSString *)sql;
+(NSMutableArray *) selectMyOrderMenus:(NSString *)sql;
+(NSMutableArray *) selectRemoteMenus:(NSString *)sql;
+(NSMutableArray *) selectRemoteDishes:(NSString *)sql;
+(NSMutableArray *) selectOtherImages:(NSString *)sql;

+(float) getPluBookCount;
+(float) getPluMenuCount:(NSString *)pmCode;
+(float) getPluSortCount:(NSString *)psCode;
+(float) getPluPluCount:(NSString *)ppCode;
+(float) getTotalNumber;
+(float) getTotalAmount;
+(NSString *) getMyOrderNumber:(NSString *)sql column:(NSString *)colName;
+(void) Update:(NSString *)sql;
@end
